

DROP TABLE IF EXISTS jms_dm.dm_robot_merge_kpi_network_sum_dt;

create external table jms_dm.dm_robot_merge_kpi_network_sum_dt
(
stat_date string comment '统计日期',
network_code string comment '网点code',
network_name string comment '网点名称',
network_type string comment '机构类型',
proxy_area_code string comment '代理区code',
proxy_area_name string comment '代理区name',
order_source_name string comment '订单来源name',
need_sign_cnt decimal(16,2) comment '应签收量',
all_sign_24 decimal(16,2) comment '24点准点签收量',
complaint_cnt decimal(16,2) comment '客诉票数',
hand_over_in_time_num decimal(16,2) comment '准点票数',
should_hand_over_num decimal(16,2) comment '应交接票数'
)
COMMENT '桃花岛机器人推送指标网点汇总表'
PARTITIONED BY (dt STRING COMMENT '分区日期')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_robot_merge_kpi_network_sum_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );